{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# -*- coding:utf-8 -*-\n",
    "import pandas as pd\n",
    "from pandas import DataFrame\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 读取类型1的表格中的颜色矩数据\n",
    "d1 = pd.read_csv('a.csv',encoding=\"gbk\")\n",
    "# 读取类型2的表格中的颜色矩数据\n",
    "d2 = pd.read_csv('b.csv',encoding=\"gbk\")\n",
    "# 读取类型3的表格中的颜色矩数据\n",
    "d3 = pd.read_csv('c.csv',encoding=\"gbk\")\n",
    "# 读取类型4的表格中的颜色矩数据\n",
    "d4 = pd.read_csv('d.csv',encoding=\"gbk\")\n",
    "# 读取类型5的表格中的颜色矩数据\n",
    "d5 = pd.read_csv('e.csv',encoding=\"gbk\")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>typenum</th>\n",
       "      <th>R通道一阶矩</th>\n",
       "      <th>G通道一阶矩</th>\n",
       "      <th>B通道一阶矩</th>\n",
       "      <th>R通道二阶矩</th>\n",
       "      <th>G通道二阶矩</th>\n",
       "      <th>B通道二阶矩</th>\n",
       "      <th>R通道三阶矩</th>\n",
       "      <th>G通道三阶矩</th>\n",
       "      <th>B通道三阶矩</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>26.6236</td>\n",
       "      <td>148.3309</td>\n",
       "      <td>134.4576</td>\n",
       "      <td>0.775063</td>\n",
       "      <td>21.133996</td>\n",
       "      <td>3.753559</td>\n",
       "      <td>0.953489</td>\n",
       "      <td>27.415011</td>\n",
       "      <td>4.378080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>24.9852</td>\n",
       "      <td>176.1718</td>\n",
       "      <td>174.7812</td>\n",
       "      <td>0.245318</td>\n",
       "      <td>4.353675</td>\n",
       "      <td>2.958873</td>\n",
       "      <td>0.401434</td>\n",
       "      <td>5.126858</td>\n",
       "      <td>3.340715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>28.0781</td>\n",
       "      <td>114.3159</td>\n",
       "      <td>150.0292</td>\n",
       "      <td>0.669627</td>\n",
       "      <td>4.857253</td>\n",
       "      <td>1.793920</td>\n",
       "      <td>0.894535</td>\n",
       "      <td>5.371815</td>\n",
       "      <td>2.140481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>30.8133</td>\n",
       "      <td>123.7827</td>\n",
       "      <td>149.8406</td>\n",
       "      <td>0.881841</td>\n",
       "      <td>3.224854</td>\n",
       "      <td>1.597996</td>\n",
       "      <td>1.083605</td>\n",
       "      <td>3.916306</td>\n",
       "      <td>1.894363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>30.7454</td>\n",
       "      <td>129.3076</td>\n",
       "      <td>146.5720</td>\n",
       "      <td>0.664664</td>\n",
       "      <td>4.970672</td>\n",
       "      <td>1.451488</td>\n",
       "      <td>0.839377</td>\n",
       "      <td>5.973109</td>\n",
       "      <td>1.739011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>28.8999</td>\n",
       "      <td>106.7924</td>\n",
       "      <td>146.1161</td>\n",
       "      <td>0.732038</td>\n",
       "      <td>4.102231</td>\n",
       "      <td>1.606182</td>\n",
       "      <td>0.962427</td>\n",
       "      <td>4.829001</td>\n",
       "      <td>1.899900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>28.3093</td>\n",
       "      <td>130.2321</td>\n",
       "      <td>149.5247</td>\n",
       "      <td>0.603683</td>\n",
       "      <td>3.748364</td>\n",
       "      <td>1.314606</td>\n",
       "      <td>0.715406</td>\n",
       "      <td>4.852039</td>\n",
       "      <td>1.599628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>22.6349</td>\n",
       "      <td>154.0294</td>\n",
       "      <td>163.9997</td>\n",
       "      <td>0.581723</td>\n",
       "      <td>4.401992</td>\n",
       "      <td>1.852647</td>\n",
       "      <td>0.668257</td>\n",
       "      <td>5.203707</td>\n",
       "      <td>2.186966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>22.7761</td>\n",
       "      <td>152.9785</td>\n",
       "      <td>162.6158</td>\n",
       "      <td>0.505538</td>\n",
       "      <td>4.321277</td>\n",
       "      <td>1.809141</td>\n",
       "      <td>0.624070</td>\n",
       "      <td>4.944566</td>\n",
       "      <td>2.173096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>25.0039</td>\n",
       "      <td>88.1922</td>\n",
       "      <td>155.6327</td>\n",
       "      <td>1.172725</td>\n",
       "      <td>3.995430</td>\n",
       "      <td>3.806125</td>\n",
       "      <td>1.326403</td>\n",
       "      <td>4.711509</td>\n",
       "      <td>4.229858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>24.0376</td>\n",
       "      <td>142.8059</td>\n",
       "      <td>151.4253</td>\n",
       "      <td>0.772519</td>\n",
       "      <td>4.124539</td>\n",
       "      <td>3.092446</td>\n",
       "      <td>0.920919</td>\n",
       "      <td>4.976178</td>\n",
       "      <td>3.615012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>26.8977</td>\n",
       "      <td>139.7115</td>\n",
       "      <td>149.5422</td>\n",
       "      <td>0.543907</td>\n",
       "      <td>2.936847</td>\n",
       "      <td>1.661511</td>\n",
       "      <td>0.736548</td>\n",
       "      <td>3.758899</td>\n",
       "      <td>1.993115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>24.1228</td>\n",
       "      <td>156.6138</td>\n",
       "      <td>144.7738</td>\n",
       "      <td>0.602429</td>\n",
       "      <td>3.983572</td>\n",
       "      <td>1.896585</td>\n",
       "      <td>0.821995</td>\n",
       "      <td>4.694719</td>\n",
       "      <td>2.276323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>23.1972</td>\n",
       "      <td>154.9284</td>\n",
       "      <td>156.7120</td>\n",
       "      <td>0.503500</td>\n",
       "      <td>4.764543</td>\n",
       "      <td>1.872714</td>\n",
       "      <td>0.624061</td>\n",
       "      <td>5.328584</td>\n",
       "      <td>2.283578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>25.8906</td>\n",
       "      <td>123.8557</td>\n",
       "      <td>143.6054</td>\n",
       "      <td>0.516751</td>\n",
       "      <td>3.518448</td>\n",
       "      <td>1.720433</td>\n",
       "      <td>0.722227</td>\n",
       "      <td>4.099186</td>\n",
       "      <td>2.126349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>28.5116</td>\n",
       "      <td>139.4087</td>\n",
       "      <td>164.4591</td>\n",
       "      <td>0.663826</td>\n",
       "      <td>3.604201</td>\n",
       "      <td>1.879129</td>\n",
       "      <td>0.790100</td>\n",
       "      <td>4.435385</td>\n",
       "      <td>2.206191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>32.9704</td>\n",
       "      <td>132.2491</td>\n",
       "      <td>140.9581</td>\n",
       "      <td>0.639159</td>\n",
       "      <td>4.297773</td>\n",
       "      <td>1.261089</td>\n",
       "      <td>0.920112</td>\n",
       "      <td>5.133700</td>\n",
       "      <td>1.487973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>33.9300</td>\n",
       "      <td>110.0358</td>\n",
       "      <td>152.2122</td>\n",
       "      <td>0.493457</td>\n",
       "      <td>2.917965</td>\n",
       "      <td>1.202569</td>\n",
       "      <td>0.736137</td>\n",
       "      <td>3.662069</td>\n",
       "      <td>1.416236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>29.4146</td>\n",
       "      <td>142.1756</td>\n",
       "      <td>147.3425</td>\n",
       "      <td>0.562234</td>\n",
       "      <td>4.102848</td>\n",
       "      <td>1.338878</td>\n",
       "      <td>0.628506</td>\n",
       "      <td>4.703373</td>\n",
       "      <td>1.603703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>26.7768</td>\n",
       "      <td>186.2854</td>\n",
       "      <td>177.0464</td>\n",
       "      <td>0.427764</td>\n",
       "      <td>2.412498</td>\n",
       "      <td>2.135989</td>\n",
       "      <td>0.498914</td>\n",
       "      <td>2.832842</td>\n",
       "      <td>2.499304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>25.9711</td>\n",
       "      <td>185.6239</td>\n",
       "      <td>179.6203</td>\n",
       "      <td>0.374252</td>\n",
       "      <td>2.645836</td>\n",
       "      <td>2.213126</td>\n",
       "      <td>0.517721</td>\n",
       "      <td>3.087029</td>\n",
       "      <td>2.592045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>27.1831</td>\n",
       "      <td>134.7962</td>\n",
       "      <td>123.1692</td>\n",
       "      <td>0.871765</td>\n",
       "      <td>5.012152</td>\n",
       "      <td>3.897662</td>\n",
       "      <td>1.139186</td>\n",
       "      <td>5.994930</td>\n",
       "      <td>4.492724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>27.0355</td>\n",
       "      <td>126.1451</td>\n",
       "      <td>154.3376</td>\n",
       "      <td>0.518112</td>\n",
       "      <td>4.514294</td>\n",
       "      <td>1.598195</td>\n",
       "      <td>0.717173</td>\n",
       "      <td>5.273919</td>\n",
       "      <td>1.903037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>27.0004</td>\n",
       "      <td>157.3573</td>\n",
       "      <td>154.8663</td>\n",
       "      <td>0.617414</td>\n",
       "      <td>3.546637</td>\n",
       "      <td>2.830835</td>\n",
       "      <td>0.780806</td>\n",
       "      <td>4.465542</td>\n",
       "      <td>3.213031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>28.6658</td>\n",
       "      <td>133.6240</td>\n",
       "      <td>133.4514</td>\n",
       "      <td>0.676395</td>\n",
       "      <td>3.803633</td>\n",
       "      <td>1.652162</td>\n",
       "      <td>0.806943</td>\n",
       "      <td>4.721340</td>\n",
       "      <td>2.014948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1</td>\n",
       "      <td>26.1080</td>\n",
       "      <td>178.6740</td>\n",
       "      <td>207.5896</td>\n",
       "      <td>0.362679</td>\n",
       "      <td>2.832194</td>\n",
       "      <td>4.577376</td>\n",
       "      <td>0.485111</td>\n",
       "      <td>3.270955</td>\n",
       "      <td>5.257254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1</td>\n",
       "      <td>25.9184</td>\n",
       "      <td>178.7401</td>\n",
       "      <td>207.6741</td>\n",
       "      <td>0.443330</td>\n",
       "      <td>2.265867</td>\n",
       "      <td>5.044412</td>\n",
       "      <td>0.572532</td>\n",
       "      <td>2.637787</td>\n",
       "      <td>5.749149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1</td>\n",
       "      <td>29.8304</td>\n",
       "      <td>188.4960</td>\n",
       "      <td>159.7948</td>\n",
       "      <td>0.404025</td>\n",
       "      <td>4.369003</td>\n",
       "      <td>2.635203</td>\n",
       "      <td>0.517974</td>\n",
       "      <td>4.907160</td>\n",
       "      <td>2.994773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>29.7394</td>\n",
       "      <td>195.5967</td>\n",
       "      <td>156.3383</td>\n",
       "      <td>0.512140</td>\n",
       "      <td>4.133794</td>\n",
       "      <td>2.477106</td>\n",
       "      <td>0.621838</td>\n",
       "      <td>4.692305</td>\n",
       "      <td>2.925078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>24.8916</td>\n",
       "      <td>194.8729</td>\n",
       "      <td>159.3795</td>\n",
       "      <td>0.314721</td>\n",
       "      <td>2.349158</td>\n",
       "      <td>1.501825</td>\n",
       "      <td>0.438628</td>\n",
       "      <td>2.969061</td>\n",
       "      <td>1.764559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>4</td>\n",
       "      <td>30.9586</td>\n",
       "      <td>175.6536</td>\n",
       "      <td>124.9156</td>\n",
       "      <td>0.535617</td>\n",
       "      <td>4.963145</td>\n",
       "      <td>1.455018</td>\n",
       "      <td>0.717090</td>\n",
       "      <td>6.020310</td>\n",
       "      <td>1.704480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>4</td>\n",
       "      <td>31.8749</td>\n",
       "      <td>143.3534</td>\n",
       "      <td>122.6481</td>\n",
       "      <td>1.385875</td>\n",
       "      <td>2.406597</td>\n",
       "      <td>1.723678</td>\n",
       "      <td>1.480717</td>\n",
       "      <td>2.873621</td>\n",
       "      <td>1.998769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>4</td>\n",
       "      <td>26.8323</td>\n",
       "      <td>165.7764</td>\n",
       "      <td>95.5375</td>\n",
       "      <td>1.074978</td>\n",
       "      <td>5.348047</td>\n",
       "      <td>2.996797</td>\n",
       "      <td>1.309167</td>\n",
       "      <td>6.467052</td>\n",
       "      <td>3.420446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>4</td>\n",
       "      <td>32.9219</td>\n",
       "      <td>151.1319</td>\n",
       "      <td>108.9217</td>\n",
       "      <td>0.796744</td>\n",
       "      <td>4.799636</td>\n",
       "      <td>1.461290</td>\n",
       "      <td>1.051914</td>\n",
       "      <td>5.573000</td>\n",
       "      <td>1.734060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>4</td>\n",
       "      <td>34.2205</td>\n",
       "      <td>144.3896</td>\n",
       "      <td>121.5871</td>\n",
       "      <td>1.014041</td>\n",
       "      <td>5.786537</td>\n",
       "      <td>2.261551</td>\n",
       "      <td>1.254393</td>\n",
       "      <td>6.954122</td>\n",
       "      <td>2.651655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>4</td>\n",
       "      <td>32.8381</td>\n",
       "      <td>155.0993</td>\n",
       "      <td>135.2511</td>\n",
       "      <td>0.685776</td>\n",
       "      <td>4.786882</td>\n",
       "      <td>2.790063</td>\n",
       "      <td>0.938748</td>\n",
       "      <td>5.829277</td>\n",
       "      <td>3.234056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>4</td>\n",
       "      <td>30.5824</td>\n",
       "      <td>179.8541</td>\n",
       "      <td>127.7870</td>\n",
       "      <td>1.035959</td>\n",
       "      <td>24.623757</td>\n",
       "      <td>7.602081</td>\n",
       "      <td>1.272126</td>\n",
       "      <td>27.845685</td>\n",
       "      <td>8.503880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>4</td>\n",
       "      <td>34.0658</td>\n",
       "      <td>148.2305</td>\n",
       "      <td>120.5046</td>\n",
       "      <td>0.740858</td>\n",
       "      <td>6.656378</td>\n",
       "      <td>1.455259</td>\n",
       "      <td>0.988915</td>\n",
       "      <td>7.768618</td>\n",
       "      <td>1.811194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>4</td>\n",
       "      <td>33.0026</td>\n",
       "      <td>163.1290</td>\n",
       "      <td>122.2040</td>\n",
       "      <td>0.499193</td>\n",
       "      <td>3.923768</td>\n",
       "      <td>1.395200</td>\n",
       "      <td>0.712873</td>\n",
       "      <td>5.040265</td>\n",
       "      <td>1.678366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>4</td>\n",
       "      <td>34.4204</td>\n",
       "      <td>155.3460</td>\n",
       "      <td>118.5451</td>\n",
       "      <td>0.706869</td>\n",
       "      <td>5.308266</td>\n",
       "      <td>1.299910</td>\n",
       "      <td>0.891418</td>\n",
       "      <td>6.267456</td>\n",
       "      <td>1.535384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>4</td>\n",
       "      <td>29.0454</td>\n",
       "      <td>173.0162</td>\n",
       "      <td>127.2512</td>\n",
       "      <td>0.546204</td>\n",
       "      <td>5.007189</td>\n",
       "      <td>1.398820</td>\n",
       "      <td>0.739916</td>\n",
       "      <td>5.922129</td>\n",
       "      <td>1.654624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>4</td>\n",
       "      <td>31.6784</td>\n",
       "      <td>165.4682</td>\n",
       "      <td>123.8970</td>\n",
       "      <td>1.009937</td>\n",
       "      <td>4.307388</td>\n",
       "      <td>1.479929</td>\n",
       "      <td>1.089785</td>\n",
       "      <td>5.424091</td>\n",
       "      <td>1.763349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>4</td>\n",
       "      <td>29.1263</td>\n",
       "      <td>175.3022</td>\n",
       "      <td>127.7361</td>\n",
       "      <td>0.504131</td>\n",
       "      <td>4.385804</td>\n",
       "      <td>1.334263</td>\n",
       "      <td>0.681679</td>\n",
       "      <td>5.438593</td>\n",
       "      <td>1.586831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>4</td>\n",
       "      <td>28.8526</td>\n",
       "      <td>177.1158</td>\n",
       "      <td>132.0197</td>\n",
       "      <td>0.625998</td>\n",
       "      <td>5.088280</td>\n",
       "      <td>1.688820</td>\n",
       "      <td>0.761496</td>\n",
       "      <td>5.985421</td>\n",
       "      <td>1.983044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>4</td>\n",
       "      <td>32.6407</td>\n",
       "      <td>123.7283</td>\n",
       "      <td>123.9924</td>\n",
       "      <td>6.866965</td>\n",
       "      <td>34.800510</td>\n",
       "      <td>13.219234</td>\n",
       "      <td>13.374928</td>\n",
       "      <td>47.915747</td>\n",
       "      <td>17.059189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>4</td>\n",
       "      <td>30.6064</td>\n",
       "      <td>110.6994</td>\n",
       "      <td>128.1121</td>\n",
       "      <td>1.950764</td>\n",
       "      <td>34.720735</td>\n",
       "      <td>13.746677</td>\n",
       "      <td>2.454394</td>\n",
       "      <td>41.801773</td>\n",
       "      <td>15.539120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>4</td>\n",
       "      <td>30.2751</td>\n",
       "      <td>146.2886</td>\n",
       "      <td>126.9532</td>\n",
       "      <td>0.619855</td>\n",
       "      <td>7.540180</td>\n",
       "      <td>4.117476</td>\n",
       "      <td>0.850998</td>\n",
       "      <td>8.883709</td>\n",
       "      <td>4.940895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>4</td>\n",
       "      <td>31.4879</td>\n",
       "      <td>171.2417</td>\n",
       "      <td>127.6773</td>\n",
       "      <td>0.790603</td>\n",
       "      <td>5.247197</td>\n",
       "      <td>1.507702</td>\n",
       "      <td>0.916386</td>\n",
       "      <td>6.356041</td>\n",
       "      <td>1.811102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>4</td>\n",
       "      <td>27.9111</td>\n",
       "      <td>159.1909</td>\n",
       "      <td>156.7179</td>\n",
       "      <td>0.747126</td>\n",
       "      <td>14.143177</td>\n",
       "      <td>3.590755</td>\n",
       "      <td>0.872503</td>\n",
       "      <td>15.901359</td>\n",
       "      <td>4.205751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>4</td>\n",
       "      <td>26.7554</td>\n",
       "      <td>184.8214</td>\n",
       "      <td>153.3746</td>\n",
       "      <td>0.597638</td>\n",
       "      <td>4.162319</td>\n",
       "      <td>2.930166</td>\n",
       "      <td>0.698306</td>\n",
       "      <td>4.814724</td>\n",
       "      <td>3.382775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>4</td>\n",
       "      <td>30.2732</td>\n",
       "      <td>90.5210</td>\n",
       "      <td>122.8358</td>\n",
       "      <td>1.719175</td>\n",
       "      <td>13.308552</td>\n",
       "      <td>4.571328</td>\n",
       "      <td>2.006653</td>\n",
       "      <td>15.093482</td>\n",
       "      <td>5.322660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>4</td>\n",
       "      <td>30.4693</td>\n",
       "      <td>101.7120</td>\n",
       "      <td>118.2033</td>\n",
       "      <td>1.639103</td>\n",
       "      <td>10.924855</td>\n",
       "      <td>2.542945</td>\n",
       "      <td>1.898000</td>\n",
       "      <td>12.451959</td>\n",
       "      <td>3.023341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>4</td>\n",
       "      <td>27.6582</td>\n",
       "      <td>115.9400</td>\n",
       "      <td>125.6478</td>\n",
       "      <td>0.636532</td>\n",
       "      <td>5.468857</td>\n",
       "      <td>2.012102</td>\n",
       "      <td>0.770019</td>\n",
       "      <td>6.518941</td>\n",
       "      <td>2.280913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>4</td>\n",
       "      <td>29.1406</td>\n",
       "      <td>139.8757</td>\n",
       "      <td>108.0230</td>\n",
       "      <td>0.871568</td>\n",
       "      <td>7.017140</td>\n",
       "      <td>1.482252</td>\n",
       "      <td>1.154320</td>\n",
       "      <td>8.116193</td>\n",
       "      <td>1.768965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>5</td>\n",
       "      <td>50.0184</td>\n",
       "      <td>143.4977</td>\n",
       "      <td>71.4884</td>\n",
       "      <td>0.613565</td>\n",
       "      <td>4.112590</td>\n",
       "      <td>1.479617</td>\n",
       "      <td>0.913864</td>\n",
       "      <td>5.498476</td>\n",
       "      <td>1.702308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>5</td>\n",
       "      <td>43.0452</td>\n",
       "      <td>183.2863</td>\n",
       "      <td>98.6715</td>\n",
       "      <td>0.650044</td>\n",
       "      <td>3.715822</td>\n",
       "      <td>1.777129</td>\n",
       "      <td>0.935026</td>\n",
       "      <td>4.428756</td>\n",
       "      <td>2.167627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>5</td>\n",
       "      <td>37.3611</td>\n",
       "      <td>147.5466</td>\n",
       "      <td>123.8322</td>\n",
       "      <td>0.662500</td>\n",
       "      <td>5.934309</td>\n",
       "      <td>2.522745</td>\n",
       "      <td>0.788394</td>\n",
       "      <td>7.118136</td>\n",
       "      <td>2.963584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>5</td>\n",
       "      <td>36.2162</td>\n",
       "      <td>164.3718</td>\n",
       "      <td>134.1734</td>\n",
       "      <td>0.491383</td>\n",
       "      <td>7.178688</td>\n",
       "      <td>1.928350</td>\n",
       "      <td>0.593595</td>\n",
       "      <td>8.290610</td>\n",
       "      <td>2.312633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>5</td>\n",
       "      <td>36.4776</td>\n",
       "      <td>164.8013</td>\n",
       "      <td>141.8560</td>\n",
       "      <td>0.526781</td>\n",
       "      <td>6.804235</td>\n",
       "      <td>2.238541</td>\n",
       "      <td>0.556056</td>\n",
       "      <td>7.944313</td>\n",
       "      <td>2.674182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>5</td>\n",
       "      <td>27.1432</td>\n",
       "      <td>120.0828</td>\n",
       "      <td>176.0701</td>\n",
       "      <td>0.368095</td>\n",
       "      <td>2.400447</td>\n",
       "      <td>2.948930</td>\n",
       "      <td>0.473465</td>\n",
       "      <td>2.808496</td>\n",
       "      <td>3.366830</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>203 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     typenum   R通道一阶矩    G通道一阶矩    B通道一阶矩    R通道二阶矩     G通道二阶矩     B通道二阶矩  \\\n",
       "0          1  26.6236  148.3309  134.4576  0.775063  21.133996   3.753559   \n",
       "1          1  24.9852  176.1718  174.7812  0.245318   4.353675   2.958873   \n",
       "2          1  28.0781  114.3159  150.0292  0.669627   4.857253   1.793920   \n",
       "3          1  30.8133  123.7827  149.8406  0.881841   3.224854   1.597996   \n",
       "4          1  30.7454  129.3076  146.5720  0.664664   4.970672   1.451488   \n",
       "5          1  28.8999  106.7924  146.1161  0.732038   4.102231   1.606182   \n",
       "6          1  28.3093  130.2321  149.5247  0.603683   3.748364   1.314606   \n",
       "7          1  22.6349  154.0294  163.9997  0.581723   4.401992   1.852647   \n",
       "8          1  22.7761  152.9785  162.6158  0.505538   4.321277   1.809141   \n",
       "9          1  25.0039   88.1922  155.6327  1.172725   3.995430   3.806125   \n",
       "10         1  24.0376  142.8059  151.4253  0.772519   4.124539   3.092446   \n",
       "11         1  26.8977  139.7115  149.5422  0.543907   2.936847   1.661511   \n",
       "12         1  24.1228  156.6138  144.7738  0.602429   3.983572   1.896585   \n",
       "13         1  23.1972  154.9284  156.7120  0.503500   4.764543   1.872714   \n",
       "14         1  25.8906  123.8557  143.6054  0.516751   3.518448   1.720433   \n",
       "15         1  28.5116  139.4087  164.4591  0.663826   3.604201   1.879129   \n",
       "16         1  32.9704  132.2491  140.9581  0.639159   4.297773   1.261089   \n",
       "17         1  33.9300  110.0358  152.2122  0.493457   2.917965   1.202569   \n",
       "18         1  29.4146  142.1756  147.3425  0.562234   4.102848   1.338878   \n",
       "19         1  26.7768  186.2854  177.0464  0.427764   2.412498   2.135989   \n",
       "20         1  25.9711  185.6239  179.6203  0.374252   2.645836   2.213126   \n",
       "21         1  27.1831  134.7962  123.1692  0.871765   5.012152   3.897662   \n",
       "22         1  27.0355  126.1451  154.3376  0.518112   4.514294   1.598195   \n",
       "23         1  27.0004  157.3573  154.8663  0.617414   3.546637   2.830835   \n",
       "24         1  28.6658  133.6240  133.4514  0.676395   3.803633   1.652162   \n",
       "25         1  26.1080  178.6740  207.5896  0.362679   2.832194   4.577376   \n",
       "26         1  25.9184  178.7401  207.6741  0.443330   2.265867   5.044412   \n",
       "27         1  29.8304  188.4960  159.7948  0.404025   4.369003   2.635203   \n",
       "28         1  29.7394  195.5967  156.3383  0.512140   4.133794   2.477106   \n",
       "29         1  24.8916  194.8729  159.3795  0.314721   2.349158   1.501825   \n",
       "..       ...      ...       ...       ...       ...        ...        ...   \n",
       "173        4  30.9586  175.6536  124.9156  0.535617   4.963145   1.455018   \n",
       "174        4  31.8749  143.3534  122.6481  1.385875   2.406597   1.723678   \n",
       "175        4  26.8323  165.7764   95.5375  1.074978   5.348047   2.996797   \n",
       "176        4  32.9219  151.1319  108.9217  0.796744   4.799636   1.461290   \n",
       "177        4  34.2205  144.3896  121.5871  1.014041   5.786537   2.261551   \n",
       "178        4  32.8381  155.0993  135.2511  0.685776   4.786882   2.790063   \n",
       "179        4  30.5824  179.8541  127.7870  1.035959  24.623757   7.602081   \n",
       "180        4  34.0658  148.2305  120.5046  0.740858   6.656378   1.455259   \n",
       "181        4  33.0026  163.1290  122.2040  0.499193   3.923768   1.395200   \n",
       "182        4  34.4204  155.3460  118.5451  0.706869   5.308266   1.299910   \n",
       "183        4  29.0454  173.0162  127.2512  0.546204   5.007189   1.398820   \n",
       "184        4  31.6784  165.4682  123.8970  1.009937   4.307388   1.479929   \n",
       "185        4  29.1263  175.3022  127.7361  0.504131   4.385804   1.334263   \n",
       "186        4  28.8526  177.1158  132.0197  0.625998   5.088280   1.688820   \n",
       "187        4  32.6407  123.7283  123.9924  6.866965  34.800510  13.219234   \n",
       "188        4  30.6064  110.6994  128.1121  1.950764  34.720735  13.746677   \n",
       "189        4  30.2751  146.2886  126.9532  0.619855   7.540180   4.117476   \n",
       "190        4  31.4879  171.2417  127.6773  0.790603   5.247197   1.507702   \n",
       "191        4  27.9111  159.1909  156.7179  0.747126  14.143177   3.590755   \n",
       "192        4  26.7554  184.8214  153.3746  0.597638   4.162319   2.930166   \n",
       "193        4  30.2732   90.5210  122.8358  1.719175  13.308552   4.571328   \n",
       "194        4  30.4693  101.7120  118.2033  1.639103  10.924855   2.542945   \n",
       "195        4  27.6582  115.9400  125.6478  0.636532   5.468857   2.012102   \n",
       "196        4  29.1406  139.8757  108.0230  0.871568   7.017140   1.482252   \n",
       "197        5  50.0184  143.4977   71.4884  0.613565   4.112590   1.479617   \n",
       "198        5  43.0452  183.2863   98.6715  0.650044   3.715822   1.777129   \n",
       "199        5  37.3611  147.5466  123.8322  0.662500   5.934309   2.522745   \n",
       "200        5  36.2162  164.3718  134.1734  0.491383   7.178688   1.928350   \n",
       "201        5  36.4776  164.8013  141.8560  0.526781   6.804235   2.238541   \n",
       "202        5  27.1432  120.0828  176.0701  0.368095   2.400447   2.948930   \n",
       "\n",
       "        R通道三阶矩     G通道三阶矩     B通道三阶矩  \n",
       "0     0.953489  27.415011   4.378080  \n",
       "1     0.401434   5.126858   3.340715  \n",
       "2     0.894535   5.371815   2.140481  \n",
       "3     1.083605   3.916306   1.894363  \n",
       "4     0.839377   5.973109   1.739011  \n",
       "5     0.962427   4.829001   1.899900  \n",
       "6     0.715406   4.852039   1.599628  \n",
       "7     0.668257   5.203707   2.186966  \n",
       "8     0.624070   4.944566   2.173096  \n",
       "9     1.326403   4.711509   4.229858  \n",
       "10    0.920919   4.976178   3.615012  \n",
       "11    0.736548   3.758899   1.993115  \n",
       "12    0.821995   4.694719   2.276323  \n",
       "13    0.624061   5.328584   2.283578  \n",
       "14    0.722227   4.099186   2.126349  \n",
       "15    0.790100   4.435385   2.206191  \n",
       "16    0.920112   5.133700   1.487973  \n",
       "17    0.736137   3.662069   1.416236  \n",
       "18    0.628506   4.703373   1.603703  \n",
       "19    0.498914   2.832842   2.499304  \n",
       "20    0.517721   3.087029   2.592045  \n",
       "21    1.139186   5.994930   4.492724  \n",
       "22    0.717173   5.273919   1.903037  \n",
       "23    0.780806   4.465542   3.213031  \n",
       "24    0.806943   4.721340   2.014948  \n",
       "25    0.485111   3.270955   5.257254  \n",
       "26    0.572532   2.637787   5.749149  \n",
       "27    0.517974   4.907160   2.994773  \n",
       "28    0.621838   4.692305   2.925078  \n",
       "29    0.438628   2.969061   1.764559  \n",
       "..         ...        ...        ...  \n",
       "173   0.717090   6.020310   1.704480  \n",
       "174   1.480717   2.873621   1.998769  \n",
       "175   1.309167   6.467052   3.420446  \n",
       "176   1.051914   5.573000   1.734060  \n",
       "177   1.254393   6.954122   2.651655  \n",
       "178   0.938748   5.829277   3.234056  \n",
       "179   1.272126  27.845685   8.503880  \n",
       "180   0.988915   7.768618   1.811194  \n",
       "181   0.712873   5.040265   1.678366  \n",
       "182   0.891418   6.267456   1.535384  \n",
       "183   0.739916   5.922129   1.654624  \n",
       "184   1.089785   5.424091   1.763349  \n",
       "185   0.681679   5.438593   1.586831  \n",
       "186   0.761496   5.985421   1.983044  \n",
       "187  13.374928  47.915747  17.059189  \n",
       "188   2.454394  41.801773  15.539120  \n",
       "189   0.850998   8.883709   4.940895  \n",
       "190   0.916386   6.356041   1.811102  \n",
       "191   0.872503  15.901359   4.205751  \n",
       "192   0.698306   4.814724   3.382775  \n",
       "193   2.006653  15.093482   5.322660  \n",
       "194   1.898000  12.451959   3.023341  \n",
       "195   0.770019   6.518941   2.280913  \n",
       "196   1.154320   8.116193   1.768965  \n",
       "197   0.913864   5.498476   1.702308  \n",
       "198   0.935026   4.428756   2.167627  \n",
       "199   0.788394   7.118136   2.963584  \n",
       "200   0.593595   8.290610   2.312633  \n",
       "201   0.556056   7.944313   2.674182  \n",
       "202   0.473465   2.808496   3.366830  \n",
       "\n",
       "[203 rows x 10 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ALLDATA = pd.concat([d1,d2,d3,d4,d5],ignore_index=True) # 做表格连接\n",
    "del ALLDATA[u'Unnamed: 0'] # 删除掉无用列\n",
    "ALLDATA.to_excel('ALLDATA.xlsx',index=False) # 存储数据\n",
    "ALLDATA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
